﻿using System;
using System.Collections.Generic;
using System.Text;
using BtdDS;

namespace BtdDS.CDBNames
{

    public class LOAI_TD
    {
        public const decimal PHAN_QUYEN = 1;
        public const decimal DON_VI_TINH = 2;
        public const decimal LOG_LOAI_HANH_DONG = 3;
        public const decimal TU_KHOA_TIM_KIEM = 4;
    }

    public class BAO_CAO_PHUONG_AN_BT
    {
        public const string MO_TA = "MO_TA";
        public const string DON_VI = "DON_VI";
        public const string CONG_THUC_SO_LUONG = "CONG_THUC_SO_LUONG";
        public const string DON_GIA = "DON_GIA";
        public const string HS_QD = "HS_QD";
        public const string HS_DC = "HS_DC";
        public const string THANH_TIEN = "THANH_TIEN";
        public const string GHI_CHU = "GHI_CHU";
    }


    public class V_DM_LOAI_HANG_MUC_PA_DE
    {
        public const string ID = "ID";
        public const string ID_PHUONG_AN = "ID_PHUONG_AN";
        public const string ID_LOAI_HANG_MUC = "ID_LOAI_HANG_MUC";
        public const string MO_TA_HANG_MUC = "MO_TA_HANG_MUC";
        public const string ID_DON_VI_TINH = "ID_DON_VI_TINH";
        public const string SO_LUONG = "SO_LUONG";
        public const string CONG_THUC_SO_LUONG = "CONG_THUC_SO_LUONG";
        public const string DON_GIA = "DON_GIA";
        public const string HE_SO_QUY_DINH = "HE_SO_QUY_DINH";
        public const string HE_SO_DIEU_CHINH = "HE_SO_DIEU_CHINH";
        public const string THANH_TIEN = "THANH_TIEN";
        public const string GHI_CHU = "GHI_CHU";
    }



    public class DM_DU_AN_BOI_THUONG
    {
        public const string ID = "ID";
        public const string TEN_DU_AN = "TEN_DU_AN";
        public const string DIA_DIEM = "DIA_DIEM";
        public const string HOI_DONG_BOI_THUONG = "HOI_DONG_BOI_THUONG";
        public const string LY_DO = "LY_DO";
        public const string GHI_CHU = "GHI_CHU";
    }
    public class GD_PHUONG_AN_BOI_THUONG
    {
        public const string ID = "ID";
        public const string ID_DU_AN = "ID_DU_AN";
        public const string TEN_CHU_HO = "TEN_CHU_HO";
        public const string DIA_CHI_CHU_HO = "DIA_CHI_CHU_HO";
        public const string SO_THUA = "SO_THUA";
        public const string NGAY_LAP = "NGAY_LAP";
        public const string NGUOI_LAP = "NGUOI_LAP";
        public const string GHI_CHU = "GHI_CHU";
        public const string SO_THU_TU = "SO_THU_TU";
    }

    public class GD_PHUONG_AN_DETAIL
    {
        public const string ID = "ID";
        public const string ID_PHUONG_AN = "ID_PHUONG_AN";
        public const string ID_LOAI_HANG_MUC = "ID_LOAI_HANG_MUC";
        public const string MO_TA_HANG_MUC = "MO_TA_HANG_MUC";
        public const string ID_DON_VI_TINH = "ID_DON_VI_TINH";
        public const string SO_LUONG = "SO_LUONG";
        public const string CONG_THUC_SO_LUONG = "CONG_THUC_SO_LUONG";
        public const string DON_GIA = "DON_GIA";
        public const string HE_SO_QUY_DINH = "HE_SO_QUY_DINH";
        public const string HE_SO_DIEU_CHINH = "HE_SO_DIEU_CHINH";
        public const string THANH_TIEN = "THANH_TIEN";
        public const string GHI_CHU = "GHI_CHU";
    }



    public class DM_LOAI_HANG_MUC
    {
        public const string ID = "ID";
        public const string MA_LOAI = "MA_LOAI";
        public const string TEN_LOAI = "TEN_LOAI";
        public const string ID_LOAI_CHA = "ID_LOAI_CHA";
        public const string LEVEL_TREN_CAY = "LEVEL_TREN_CAY";
        public const string LA_LA_YN = "LA_LA_YN";
        public const string SO_THU_TU = "SO_THU_TU";
    }

    public class HT_PHAN_QUYEN_HE_THONG
    {
        public const string ID = "ID";
        public const string MA_PHAN_QUYEN = "MA_PHAN_QUYEN";
        public const string GHI_CHU = "GHI_CHU";
        public const string LOAI_PHAN_QUYEN = "LOAI_PHAN_QUYEN";
    }
    public class HT_PHAN_QUYEN_CHO_NHOM
    {
        public const string ID = "ID";
        public const string ID_NHOM_NGUOI_SU_DUNG = "ID_NHOM_NGUOI_SU_DUNG";
        public const string ID_PHAN_QUYEN_HE_THONG = "ID_PHAN_QUYEN_HE_THONG";
    }

    public class HT_NHOM_NGUOI_SU_DUNG
    {
        public const string ID = "ID";
        public const string MA_NHOM = "MA_NHOM";
        public const string GHI_CHU = "GHI_CHU";
        public const string TRANG_THAI_NHOM = "TRANG_THAI_NHOM";
        public const string ID_INPUTED_BY = "ID_INPUTED_BY";
        public const string INPUTED_DATE = "INPUTED_DATE";
        public const string ID_LAST_UPDATED_BY = "ID_LAST_UPDATED_BY";
        public const string LAS_UPDATED_DATE = "LAS_UPDATED_DATE";
    }


    
    public class LOG_DOI_TUONG_TAC_DONG
    {
        public const string DANG_NHAP_XUAT = "";
        public const string DM_TU_DIEN = "Danh mục từ điển";
        public const string DM_DOT_PHAT_HANH = "Danh mục đợt phát hành";
        public const string DM_NGAY_LAM_VIEC = "Danh mục ngày làm việc";
        public const string DM_THAM_SO_NHAC_VIEC = "Danh mục tham số nhắc việc";
        public const string DM_TO_CHUC_PHAT_HANH = "Danh mục tổ chức phát hành";
        public const string DM_TRAI_CHU = "Danh mục trái chủ";
        public const string DM_TRAI_PHIEU = "Danh mục trái phiếu";
        public const string GD_CHOT_LAI = "Giao dịch chốt lãi";
        public const string GD_CHOT_LAI_DETAIL = "Chi tiết giao dịch chốt lãi";
        public const string GD_CHUYEN_NHUONG = "Giao dịch chuyển nhượng";
        public const string GD_LICH_THANH_TOAN_LAI_GOC = "Giao dịch lịch thanh toán lãi gốc";
        public const string GD_NHAC_VIEC = "Giao dịch nhắc việc";
        public const string GD_PHONG_TOA = "Giao dịch phong tỏa";
        public const string GD_GIAI_TOA = "Giao dịch giải tỏa";
        public const string GD_SO_DU_TRAI_PHIEU = "Giao dịch số dư trái phiếu";
        public const string HT_NGUOI_SU_DUNG = "Người sử dụng";
        public const string HT_THAM_SO_HE_THONG = "Tham số hệ thống";
        public const string HT_NHOM_NGUOI_SU_DUNG = "Nhóm người dùng";
    }
    public class ID_THAM_SO_HE_THONG
    {
        public const decimal CHOT_LAI_TRUOC = 16;
    }
    public class ID_DON_VI_KY_HAN
    {
        public const decimal THANG = 18;
        public const decimal NAM = 19;
    }
    
    public class CM_DM_DS_LOAI_TU_DIEN
    {
        public const string TRANG_THAI_GD = "TRANG_THAI_GD";
        public const string LOAI_TRAI_CHU = "LOAI_TRAI_CHU";
        public const string TRANG_THAI_DANH_MUC = "TRANG_THAI_DANH_MUC";
        public const string LOAI_NHAC_NHAC_VIEC = "LOAI_NHAC_NHAC_VIEC";
        public const string TT_TRUOC_NGAY_LV_GAN_NHAT = "TT_TRUOC_NGAY_LV_GAN_NHAT";
        public const string LOG_LOAI_HANH_DONG = "LOG_LOAI_HANH_DONG";
    }
    

    public class CM_DM_LOAI_TD
    {
        public const string ID = "ID";
        public const string MA_LOAI = "MA_LOAI";
        public const string TEN_LOAI = "TEN_LOAI";
    }
    public class CM_DM_TU_DIEN
    {
        public const string ID = "ID";
        public const string MA_TU_DIEN = "MA_TU_DIEN";
        public const string ID_LOAI_TU_DIEN = "ID_LOAI_TU_DIEN";
        public const string TEN_NGAN = "TEN_NGAN";
        public const string TEN = "TEN";
        public const string GHI_CHU = "GHI_CHU";
    }
    public class DM_COMPANY_INFO
    {
        public const string ID = "ID";
        public const string SHORT_NAME = "SHORT_NAME";
        public const string FULL_NAME = "FULL_NAME";
        public const string ADDRESS = "ADDRESS";
        public const string MOBLIE = "MOBLIE";
        public const string EMAIL = "EMAIL";
        public const string TAX_CODE = "TAX_CODE";
    }
    public class DM_NGAY_LAM_VIEC
    {
        public const string ID = "ID";
        public const string NGAY = "NGAY";
        public const string NGAY_LAM_VIEC_YN = "NGAY_LAM_VIEC_YN";
        public const string NGAY_LAM_VIEC_HAI_BAY_YN = "NGAY_LAM_VIEC_HAI_BAY_YN";
    }
    public class DM_THAM_SO_NHAC_VIEC
    {
        public const string ID = "ID";
        public const string ID_TRAI_PHIEU = "ID_TRAI_PHIEU";
        public const string ID_LOAI_NHAC_VIEC = "ID_LOAI_NHAC_VIEC";
        public const string SO_NGAY_NHAC_TRUOC = "SO_NGAY_NHAC_TRUOC";
    }
    public class V_DM_THAM_SO_NHAC_VIEC
    {
        public const string ID = "ID";
        public const string ID_TRAI_PHIEU = "ID_TRAI_PHIEU";
        public const string ID_LOAI_NHAC_VIEC = "ID_LOAI_NHAC_VIEC";
        public const string LOAI_NHAC_VIEC = "LOAI_NHAC_VIEC";
        public const string SO_NGAY_NHAC_TRUOC = "SO_NGAY_NHAC_TRUOC";
        public const string NGAY_LAM_VIEC_YN = "NGAY_LAM_VIEC_YN";
        public const string NOI_DUNG_NHAC = "NOI_DUNG_NHAC";
        public const string GHI_CHU = "GHI_CHU";
        public const string SO_NGAY_LAM_TRUOC_NGAY_CHINH = "SO_NGAY_LAM_TRUOC_NGAY_CHINH";
    }

    public class DOC_COLUMN_COMMENT
    {
        public const string COLUMN_NAME = "COLUMN_NAME";
        public const string TABLE_NAME = "TABLE_NAME";
        public const string COLUMN_COMMENT = "COLUMN_COMMENT";
    }
    public class DOC_TABLE_COMMENT
    {
        public const string TABLE_NAME = "TABLE_NAME";
        public const string TABLE_COMMENT = "TABLE_COMMENT";
    }
    
    public class HT_BACKUP_HISTORY
    {
        public const string ID = "ID";
        public const string NGUOI_BACKUP = "NGUOI_BACKUP";
        public const string NGAY_BACKUP = "NGAY_BACKUP";
        public const string NOI_LUU = "NOI_LUU";
        public const string TEN_FILE = "TEN_FILE";
        public const string GhI_CHU = "GhI_CHU";
    }
    public class HT_BUSINESS_PROCESS_LOCK
    {
        public const string LOCK_NAME = "LOCK_NAME";
        public const string GRANTED_SYS_DATETIME = "GRANTED_SYS_DATETIME";
    }
    public class HT_NGUOI_SU_DUNG
    {
        public const string ID = "ID";
        public const string TEN_TRUY_CAP = "TEN_TRUY_CAP";
        public const string TEN = "TEN";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string NGAY_TAO = "NGAY_TAO";
        public const string NGUOI_TAO = "NGUOI_TAO";
        public const string TRANG_THAI = "TRANG_THAI";
        public const string BUILT_IN_YN = "BUILT_IN_YN";
    }
    public class HT_QUYEN_USER
    {
        public const string ID = "ID";
        public const string ID_USER = "ID_USER";
        public const string ID_QUYEN = "ID_QUYEN";
    }
    public class HT_THAM_SO_HE_THONG
    {
        public const string ID = "ID";
        public const string LOAI_THAM_SO = "LOAI_THAM_SO";
        public const string MA_THAM_SO = "MA_THAM_SO";
        public const string PHAN_HE = "PHAN_HE";
        public const string GHI_CHU = "GHI_CHU";
        public const string KIEU_DU_LIEU = "KIEU_DU_LIEU";
        public const string GIA_TRI = "GIA_TRI";
        public const string CO_THE_NULL_YN = "CO_THE_NULL_YN";
    }
    public class RPT_NHAC_VIEC
    {
        public const string ID = "ID";
        public const string ID_NGUOI_XEM = "ID_NGUOI_XEM";
        public const string NGAY = "NGAY";
        public const string TEN_TRAI_PHIEU = "TEN_TRAI_PHIEU";
        public const string NOI_DUNG_NHAC = "NOI_DUNG_NHAC";
    }
    public class UT_SEQUENCES
    {
        public const string SEQ_NAME = "SEQ_NAME";
        public const string SEQ_VALUE = "SEQ_VALUE";
    }
    public class LOG_TRUY_CAP
    {
        public const decimal DANG_NHAP = 69;
        public const decimal DANG_XUAT = 70;
        public const decimal THEM = 71;
        public const decimal SUA = 72;
        public const decimal XOA = 73;
        public const decimal DUYET = 74;
        public const decimal IMPORT = 80;
        public const decimal CAP_NHAT_LS_THONG_THUONG = 90;
        public const decimal CAP_NHAT_LS_THOA_THUAN = 91;
        public const decimal SINH_LICH_TT_LAI_GOC = 92;
        public const decimal SINH_DS_TRA_LAI = 93;
        public const decimal TRA_LAI = 94;
        public const decimal TRA_GOC = 95;
    }
    public class V_HT_LOG_TRUY_CAP
    {
        public const string ID = "ID";
        public const string ID_DANG_NHAP = "ID_DANG_NHAP";
        public const string TEN_TRUY_CAP = "TEN_TRUY_CAP";
        public const string TEN = "TEN";
        public const string THOI_GIAN = "THOI_GIAN";
        public const string ID_LOAI_HANH_DONG = "ID_LOAI_HANH_DONG";
        public const string LOAI_HANH_DONG = "LOAI_HANH_DONG";
        public const string DOI_TUONG_THAO_TAC = "DOI_TUONG_THAO_TAC";
        public const string MO_TA = "MO_TA";
        public const string GHI_CHU = "GHI_CHU";
    }
    public class V_LOAI_VA_HANG_MUC
    {
        public const string ID = "ID";
        public const string MA_LOAI = "MA_LOAI";
        public const string TEN_LOAI = "TEN_LOAI";
        public const string ID_CHA = "ID_CHA";
        public const string ID_DV_TINH = "ID_DV_TINH";
        public const string DON_VI_TINH = "DON_VI_TINH";
        public const string DON_GIA = "DON_GIA";
        public const string GHI_CHU = "GHI_CHU";
        public const string LEVEL_TREN_CAY = "LEVEL_TREN_CAY";
        public const string LA_LA_YN = "LA_LA_YN";
        public const string SO_THU_TU = "SO_THU_TU";
        public const string LOAI_HANG_MUC_YN = "LOAI_HANG_MUC_YN";
    }

    public class V_BAO_CAO_TONG_HOP
    {
        public const string SO_THU_TU = "SO_THU_TU";
        public const string TEN_CHU_HO = "TEN_CHU_HO";
        public const string DIEN_TICH_DAT_THU_HOI = "DIEN_TICH_DAT_THU_HOI";
        public const string TEN_HANG_MUC = "TEN_HANG_MUC";
        public const string THANH_TIEN = "THANH_TIEN";
        public const string TEN_DU_AN = "TEN_DU_AN";
        public const string TONG_SO_HO = "TONG_SO_HO";
        public const string TONG = "TONG";
        public const string DIA_DIEM = "DIA_DIEM";
        public const string GHI_CHU = "GHI_CHU";
    }
    public class V_DM_DU_AN_BOI_THUONG_TONG_HOP_BAO_CAO
    {
        public const string ID = "ID";
        public const string ID_DU_AN = "ID_DU_AN";
        public const string TEN_CHU_HO = "TEN_CHU_HO";
        public const string DIA_CHI_CHU_HO = "DIA_CHI_CHU_HO";
        public const string SO_THUA = "SO_THUA";
        public const string NGAY_LAP = "NGAY_LAP";
        public const string NGUOI_LAP = "NGUOI_LAP";
        public const string GHI_CHU = "GHI_CHU";
        public const string SO_THU_TU = "SO_THU_TU";
        public const string DIEN_TICH_DAT_THU_HOI = "DIEN_TICH_DAT_THU_HOI";
        public const string PHI_DAT_DAI = "PHI_DAT_DAI";
        public const string PHI_KIEN_TRUC = "PHI_KIEN_TRUC";
        public const string PHI_HOA_MAU = "PHI_HOA_MAU";
        public const string PHI_TRO_CAP_KHAC = "PHI_TRO_CAP_KHAC";
        public const string TONG_CONG_TIEN_BOI_THUONG = "TONG_CONG_TIEN_BOI_THUONG";
    }
}
